import xlrd

class Transfer_Accounts_data:
    file = r"D:\Users\北极星的眼泪\Desktop\demo\APP自动化测试第二天\Transfer_Accounts_data.xlsx"
    book = xlrd.open_workbook(filename=file)
    st = book.sheet_by_index(0)
    lengh1 = len(st.col_values(0)[:])
    data = []
    for i in range(1, lengh1):
        data.append(st.row_values(i)[:])
    transfer_accounts_data = data